package com.dingding.order.core.pay.dao.sql;

/**
 * 
 * @ClassName: OrderPaySqlBuilder 
 * @Description: 订单支付相关业务SQL
 * @author CHEHAUNBO 
 * @date 2016年7月6日 下午5:06:02
 * @since V2.2.0
 * 
 */
public class OrderPaySQL {

	/**
	 * 获取支付推送消息
	 */
	public static String GET_PAY_PUSH = "SELECT u.aliasId,u.loginEquipment,ud.tellphone,udp.nickName,ud.nickName AS 'driverName',v.lisencePlate FROM userlogin u INNER JOIN userdetail ud ON u.uid = ud.loginId INNER JOIN userdetail udp ON udp.loginId = ? LEFT JOIN vehicleinfo v ON u.uid = v.loginId WHERE u.uid = ?";

	/**
	 * 删除临时表中的出租车订单
	 * @author CHEHUANBO
	 */
	public static String DELETE_TAXI_USERORDET = "DELETE uxt FROM usertaxiordert uxt WHERE uxt.taxiOrdertId = ?";

}
